	use AITSM
go
	insert into [Admin] values('admin','21232f297a57a5a743894a0e4a801fc3')
go
	insert into [Charges] values(0,50,50)
	insert into [Charges] values(60,75,10)
go
	insert into Students values('Lai van Bang','C0909g1','2/2/1986','Ha noi','0987654321','1','banglv@gmail.com')
go
	insert into [Fine] values('C0909g1',34,100,0)
go
	insert into Staff values('Nguyen duc Kien','kiennd','c12e01f2a13ff5587e1e9e4aedb8242d',1,'2/2/1990','kien',0)
go
	insert into [TimeSlot] values('A',7,8)
	insert into [TimeSlot] values('B',8,9)
	insert into [TimeSlot] values('C',9,10)
	insert into [TimeSlot] values('D',10,11)
	insert into [TimeSlot] values('E',11,12)
	insert into [TimeSlot] values('F',12,13)
	insert into [TimeSlot] values('G',13,14)
	insert into [TimeSlot] values('H',14,15)
	insert into [TimeSlot] values('I',15,16)
	insert into [TimeSlot] values('K',16,17)

go

	insert into [Subjects] values('C',12,12,'C')
	insert into [Subjects] values('C#',11,11,'C#')
	insert into [Subjects] values('CF',13,13,'CF')
	insert into [Subjects] values('HDJ',6,6,'HDJ')
	insert into [Subjects] values('Java',9,9,'Java')
	insert into [Subjects] values('RDBMS',12,12,'RDBMS')
go
	insert into [Courses] values ('ACCP','Engineer soft',800,1)
	insert into [Courses] values ('HDSE','Engineer soft',1300,2)
go
	insert into [Subject_Course] values('C','ACCP') ; insert into [Subject_Course] values('C','HDSE')
	insert into [Subject_Course] values('C#','ACCP') ; insert into [Subject_Course] values('C#','HDSE')
	insert into [Subject_Course] values('CF','ACCP') ; insert into [Subject_Course] values('CF','HDSE')
	insert into [Subject_Course] values('HDJ','ACCP') ; insert into [Subject_Course] values('HDJ','HDSE')
	insert into [Subject_Course] values('Java','ACCP') ; insert into [Subject_Course] values('Java','HDSE')
	insert into [Subject_Course] values('RDBMS','ACCP') ; insert into [Subject_Course] values('RDBMS','HDSE')
go
	insert into [Class] values('C0909G','HDSE',1,'8/8/2009','8/8/2012')
go
select * from [Courses]
select * from Subjects
go
